UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+a8p1i9WhPsUXmewjGDo1gw/m/0XH1C2nieyogImeL8='
WHERE
key_id = '767ee63fa9a7284bbc4321dc9dae28062a4ef4b4211cdc8487017ae527e89404'
AND (
token = '+a8p1i9WhPsUXmewjGDo1gw/m/0XH1C2nieyogImeL8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)