UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0m7JvqhAlvY3IOKF+4DYZ5hZdFNp6lCrmX2Ub+uQLfE='
WHERE
key_id = '3078831a65f0239c3ac282e3f956f6bb5bde8aaa3da762995df7110932a3d01f'
AND (
token = '0m7JvqhAlvY3IOKF+4DYZ5hZdFNp6lCrmX2Ub+uQLfE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)