UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pf9aWxEZ6kRvk98f6k6cI1k19Qa0MipYdDC2QyLEE8k='
WHERE
key_id = '1e464324e46945a9e3aba100ee4987a9d854769cb9fd3c3bee35bf65c8502202'
AND (
token = 'pf9aWxEZ6kRvk98f6k6cI1k19Qa0MipYdDC2QyLEE8k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)