UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1OEXtzES+73rS3Z4ZY40pkDQjuQh3u2c2OQNUuVrbm4='
WHERE
key_id = 'fddf7941ce001e1b9014c852f0044fe64603550e761a4d6437570798f04157a8'
AND (
token = '1OEXtzES+73rS3Z4ZY40pkDQjuQh3u2c2OQNUuVrbm4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)