UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pgt0L77MxNBuoTBFSVmKum24j4JS72Q59FUQGbkQAm4='
WHERE
key_id = 'eb216b2eeca2e7762fac8392fe38c75771166b72b3ad0f6bb70c5c7ec0613297'
AND (
token = 'pgt0L77MxNBuoTBFSVmKum24j4JS72Q59FUQGbkQAm4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)