UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GCODtiglCHT7OrMszVHwFZYhtDdozSMXbiRX37RTLSA='
WHERE
key_id = 'a787db075123603e853de87f187b005e1040d2dff22e1d65b397d0498d80b548'
AND (
token = 'GCODtiglCHT7OrMszVHwFZYhtDdozSMXbiRX37RTLSA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)