UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5p8H4qgzuWCvsff8koKNbpPZD+Kn5UVxTE2yPoQKzYY='
WHERE
key_id = '049de83834d064519e31d634b69bba4b31c55089479989deb9638ad38fb2830d'
AND (
token = '5p8H4qgzuWCvsff8koKNbpPZD+Kn5UVxTE2yPoQKzYY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)