UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TGxtK0rMldTaSvQlS8x2Cul3r0+UMXf8k0s6bbDFjcY='
WHERE
key_id = '0411e109fce6bba8164432a026aedb4a9175068d667fc50ba58c2a529661ef5a'
AND (
token = 'TGxtK0rMldTaSvQlS8x2Cul3r0+UMXf8k0s6bbDFjcY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)