UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2dS5L5kd6s86dahRlpcwC8wavm2ITyoiMHfLjbEGDCU='
WHERE
key_id = '6858fe217a929cc76f3a841ead35ca893640ca0e44edfd650a942902194fcdc5'
AND (
token = '2dS5L5kd6s86dahRlpcwC8wavm2ITyoiMHfLjbEGDCU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)