UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+uY97YRGw34UsLHJTO1uUbsOAv2I8+IhmBz2UZ5kmRI='
WHERE
key_id = 'e7bd4193204056e071763e85e8344a0a4ee9414ec07ef5ebbd2706d583ee9734'
AND (
token = '+uY97YRGw34UsLHJTO1uUbsOAv2I8+IhmBz2UZ5kmRI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)