UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mGa7WRAE+V7GrvD+B9bsZk/evPZO1Um88T3Dr4VXcSk='
WHERE
key_id = '58c596f296c873bf24128590119ae11fafe674f0c1a11f636105b80dac1f3bc0'
AND (
token = 'mGa7WRAE+V7GrvD+B9bsZk/evPZO1Um88T3Dr4VXcSk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)