UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YJR5fdZqTp+KnnHFoCpG6ttsJ0xfpm/iHlUHdDZDvJw='
WHERE
key_id = '7ff375aee406480c69033218735afe724c28b08cc9d712239855365a29c232d0'
AND (
token = 'YJR5fdZqTp+KnnHFoCpG6ttsJ0xfpm/iHlUHdDZDvJw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)