UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NguZZLaE/nypjWH+aL5gXeyxelFp/9RjwJ0lAd5OYgA='
WHERE
key_id = '7bd1d16dce673163bdf49008a615bb15358a731fd0e26e075197c4fb199a3354'
AND (
token = 'NguZZLaE/nypjWH+aL5gXeyxelFp/9RjwJ0lAd5OYgA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)