UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g8xVuSWUsCS4WuweC/07JfRVvRgJ8p575Wh1MtysZBo='
WHERE
key_id = '7e27c0d2c2855b5dd743581dc30a45e32a9e635a1941193b59ce961e8ace4bfc'
AND (
token = 'g8xVuSWUsCS4WuweC/07JfRVvRgJ8p575Wh1MtysZBo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)