UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UCtHz4BZNmJnNY1yhOt8hNzTDop/gDl77mDMUHxw4L4='
WHERE
key_id = '91959cceb432d7d62c635fdea6a31848b6f2722aeb20b9a5e3d908eee6d72743'
AND (
token = 'UCtHz4BZNmJnNY1yhOt8hNzTDop/gDl77mDMUHxw4L4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)