UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1tEXWj32SD9QWVmokswNIDr/nX1zHSY61pox4Pk/+l0='
WHERE
key_id = 'a5481dcd941f7a145ad2bb1454b39c2fb97380ae4191566a307c205facc8773a'
AND (
token = '1tEXWj32SD9QWVmokswNIDr/nX1zHSY61pox4Pk/+l0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)