UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NcghSfv58Q+lW+CwRgS1Ci5Nq6mRRpEsbI2s47iHtNs='
WHERE
key_id = 'c820baf7a68d9b627eec6170f0273357d31d55f3ab72197213b11d536053a14f'
AND (
token = 'NcghSfv58Q+lW+CwRgS1Ci5Nq6mRRpEsbI2s47iHtNs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)