UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '23XZoJQWXDStxNrqgsk0r8lJq4u+3omS+q+siC/HLFE='
WHERE
key_id = '18ae7a1491c7409bc67511c0eab95c1f8601c9a69bac3a320d86fdc85a65f062'
AND (
token = '23XZoJQWXDStxNrqgsk0r8lJq4u+3omS+q+siC/HLFE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)