UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'y/SDsmHZyS462LzaZe8HBFocd1jTs5SqU1IJ+7ESbBQ='
WHERE
key_id = '502a5501abf9fa49dca6004f9d21e8b460a28e673804f9d1c5e7e12769706296'
AND (
token = 'y/SDsmHZyS462LzaZe8HBFocd1jTs5SqU1IJ+7ESbBQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)