UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WiUYWX6TYHbUwlOcO1vP8uYqIAm8Y3E/SDda2YKIBxM='
WHERE
key_id = '5881f4baf0f086092ebd45da106280aa00bccfd344a7c1274d23ddce6168063d'
AND (
token = 'WiUYWX6TYHbUwlOcO1vP8uYqIAm8Y3E/SDda2YKIBxM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)