UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yVn4q1Ow26R471SdS4p29L7xCSqIOQY+jvsCYJzPoFA='
WHERE
key_id = '3a0c2d656909d778ded0e2df2636f1c8dbd71865e17cec726bf221ecf29e8042'
AND (
token = 'yVn4q1Ow26R471SdS4p29L7xCSqIOQY+jvsCYJzPoFA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)