UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZdItl/Uud+dOZBnSVMiOoclpm0yLfakGlHv+EeyoVCc='
WHERE
key_id = 'de3c2e7c850c368c908befd40dbf4837575cbdd8dddd1f78227b2636021173ba'
AND (
token = 'ZdItl/Uud+dOZBnSVMiOoclpm0yLfakGlHv+EeyoVCc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)