UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '01W+YmMox31Pf9ve7uLQRpF/5mJBbgFVjmT1UlYYGCg='
WHERE
key_id = 'bffe9767d2b1495d2a54a880cbbd067af9a690f949a56738228d3a6190ac7fd2'
AND (
token = '01W+YmMox31Pf9ve7uLQRpF/5mJBbgFVjmT1UlYYGCg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)