UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '71g2aJr4KU/RHLSmS9meqASmt3WmcH01wA0e4Kw6Edo='
WHERE
key_id = 'd803f429561f1be9abf415cb213beb3e98bb0e1bea0886a90ceecc5dc99d4039'
AND (
token = '71g2aJr4KU/RHLSmS9meqASmt3WmcH01wA0e4Kw6Edo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)