UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zDqpHfkR2Sl1pUZJd1PvlC4w8r+LJbrWCjmn0oo+jvY='
WHERE
key_id = '6e23c01ea0999621e4d612ddbbeb2c85fbae9bc3d24cd1dc38643c140d1bfef2'
AND (
token = 'zDqpHfkR2Sl1pUZJd1PvlC4w8r+LJbrWCjmn0oo+jvY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)