UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nGI4TBzxRfe1bIyP5XK54QMbmBPSw1j0bAHjs14dAdw='
WHERE
key_id = '02ef9136b663571e8e82c4385429951a62e41efcedcb906c57145fc13d2f2036'
AND (
token = 'nGI4TBzxRfe1bIyP5XK54QMbmBPSw1j0bAHjs14dAdw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)