UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zJIDVcb8CHLrukg7RCGarr/gBp72hM2a4iPfaM3Jt2o='
WHERE
key_id = '0267bf1b6efb47b13ffe1b10548a528a2391c2b0de689a28ed2780573044ddc2'
AND (
token = 'zJIDVcb8CHLrukg7RCGarr/gBp72hM2a4iPfaM3Jt2o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)