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