UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D4+b2LBgIC31RDKKaI2He37PXy+2mJd+4loKla3Eplo='
WHERE
key_id = 'b78fb7314b636358999681725be6993a251fb81ef1e88e819edfc17e442f6315'
AND (
token = 'D4+b2LBgIC31RDKKaI2He37PXy+2mJd+4loKla3Eplo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)