UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZJhaV780e2ZEl3P3rTagHLpW3V37X4p+fWUrptC9bXM='
WHERE
key_id = 'ec20c8014de665fadd23707a74d419fbc4b1dc64c90bc011fb38e9be8ba26c03'
AND (
token = 'ZJhaV780e2ZEl3P3rTagHLpW3V37X4p+fWUrptC9bXM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)