UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Gl9Dy7kXV4fAjC9abxD64wuDOeNG9OO9N6horYRek3I='
WHERE
key_id = '856aa07da9a2c9fae824abf7bf7e31691fd9e70a1d1c6b2d23e9c1099e215602'
AND (
token = 'Gl9Dy7kXV4fAjC9abxD64wuDOeNG9OO9N6horYRek3I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)