UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EC0p4GQa2MC1itGhdbykF2EVEHwVK57M5SvB/R5e8e0='
WHERE
key_id = 'ca9903094e6f4f2458bf5b6ac2b4d3227c321dc2429fc451f1543cf59346d131'
AND (
token = 'EC0p4GQa2MC1itGhdbykF2EVEHwVK57M5SvB/R5e8e0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)