UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'm8B+T5sTHNmQfZT7Z9yQgmOQWIn0evvweYJ1zOicOi8='
WHERE
key_id = '3d47c098b2ef1be95e5e3f4ff138e7690ccc50d84ee557c64c9e3ee4052e372c'
AND (
token = 'm8B+T5sTHNmQfZT7Z9yQgmOQWIn0evvweYJ1zOicOi8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)