UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BMxijfkhpSwUAfm8ioGYVnOpYhZpPYJ1PagBCaCu6Ro='
WHERE
key_id = '95986fb50d2d1c3fde64a0d0de7ed2c608d976ff44536df474f91abaa716a3b1'
AND (
token = 'BMxijfkhpSwUAfm8ioGYVnOpYhZpPYJ1PagBCaCu6Ro='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)