UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0HMoc+lPnLcBQsr9dpjFkgm/QU/ZdufQx99KKHo91GI='
WHERE
key_id = 'c8ad14fd71df4804a05f5033070e7c4971beaba040741ba39eccb3772448d4e0'
AND (
token = '0HMoc+lPnLcBQsr9dpjFkgm/QU/ZdufQx99KKHo91GI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)